|
|
"Gail Shaw" <initialsurname@sentech sa dot com> wrote:
> This works in SQL 2005
>
> SELECT tbl1.Col1, tbl2.col2 from tbl1 LEFT OUTER JOIN tbl2 on tbl1.Col1 =
> tbl2.Col1
>
> This doesn't
>
> SELECT tbl1.Col1, tbl2.col2 from tbl1, tbl2 WHERE tbl1.Col1 *= tbl2.Col1
I remember the Delphi programmers here at work squawking about that. They have
a lot of embedded SQL in their Delphi code that uses the old latter syntax, and
they had to go thru and fix it all. I guess that's why they get paid the big
programmer bucks :)
--
Dan
GoofyGraffix.com
Post a reply to this message
|
|